The Business Master (3rd Edition)/The Business Master (3rd Edition).iso/files/spreotus/spedcors/l53

Text File | 1992-06-06 | 5.8 KB | 199 lines

L53             ╔══════════════════════════════════╗
                ║ INTRODUCTION TO KEYBOARD MACROS  ║
                ╚══════════════════════════════════╝
                   Macros Are Great Time Savers

        Wouldn't it be nice if you could replace the 5 keystrokes
        that it takes to change the width of a column with one keystroke.
        It would be the same as having 5 pennies and replacing them
        with a nickel.

√√√     A MACRO IS LIKE A NICKEL
        It can replace 5 keystrokes with one keystroke.
        A Macro is a collection of commands that is assigned to a key.
        When that key is pressed the commands are automatically
        executed, one at a time, until all commands are processed.

  √√√   WE USE MACROS EVERY DAY
        Macros are great time savers. For example, you want
        to make a long distance call to New York (1-212-567 7890).
        You dial one number and you get your party. This is an
        example of  a Macro. You dial one number, it in turn automatically
        dials 11 numbers. The Phone people call this Speed dialing.

        Macro is Speed dialing, where you use one or two keystroke, to
        replace having to enter a number of different commands.


  √√√   LOTUS HAS ITS OWN MACRO LANGUAGE
        Lotus uses a special language for Macros.
        Here are a few that you will be using to create Macros.

        The Tilde symbol (~)       (Pronounced Til da).
        The Tilde symbol is located on the first key on the
        first row of the keyboard.
        This symbol is used in Macro formulas to indicate
        the <Enter> key. This gives the Macro an automatic
        carriage return, the same as pressing the <Enter> key.

  √√√   THE "ALT" KEY IS CALLED THE MACRO KEY
        It can be used in combination with the 26 letters of the alphabet.

  √√√   WHEN WRITING A MACRO
        Always start with  ('/)  (Apostrophe and forward slash).
        And end with (~)    (Tilde symbol).
        Next is an example using R (Range) and E (Erase).

  √√√   MACRO FORMULA FOR ERASING A CELL
        '/RE~    (~ this is the Tilde symbol).
        (This reads as...Apostrophe, Forward Slash, R E and Tilde).

  √√√  TO CREATE A MACRO FOR ERASING A CELL
       Move cursor to Cell A1 for practice.
       Type '/RE~  Press <Enter> key.

        The apostrophe (') does not appear in the cell
        because it is a label prefix character.

  √√√  TO NAME THE MACRO
       Press (/) R N C (Range, Name. Create) press <Enter> key.
       Enter name as  \E   Press <Enter> key.
       For "Enter Range" type  A1..A1.  Press <Enter> key.

                                - 27 -





  √√√  ERASING A CELL WITH THE ALT-E MACRO
       Move cursor to C1.
       Type your name.  Press <Enter> key.
       Press and hold down the Alt key.
       Press E key.    Contents (Label) in Cell C1 is erased.

  √√√  MACRO FOR CURRENCY AND TWO DECIMAL PLACES
       Macro formula  '/RFC2~
          (apostrophe, forward slash, Range, Format,
            Column, Two decimal places, and ~ (press <Enter> key).

  √√√  TO CREATE MACRO
       Move cursor to Cell C1 for practice.
       Type '/RFC2~   Press <Enter> key.


  √√√ TO NAME MACRO
      Press (/) R N C  (Range, Name, Create)
      Enter name  \C   Press <Enter> key.
      For Enter Range (C1..C1)  Press <Enter> key.

  √√√ HOW TO USE
      Move cursor to Cell D1, and type some numbers, like 34.6.
      Press and hold down the Alt key and press the C key.
      Release both keys.
      Screen says Enter range to format: D1..D1
      Since you have only one cell D1,  press <Enter> key.
      Numbers will have 2 decimal places and ($) sign.


  √√√ HOW TO SAVE YOUR MACROS
      Press (/) F S
      File to save.
      Type name of Macro (RFC2)
      Press <Enter> key.


  √√√   A MACRO FOR SAVING FILES
        You can create a Macro that will automatically
        do the above steps for you. Here's how the Macro is written.

        To Start Macro:
        Move cursor to Cell A2.
        Type  '/ F S

  √√√   TO NAME MACRO
        For name type   '/ R N C
        Press <Enter> key.
        Type in name of Macro  \S
        Upper right of screen shows
        Enter range. You press <Enter> key.

  √√√   HOW TO USE THE MACRO "Save Files"
        Press and hold down the <Alt> key.
        Now press the S key. Release both keys.
        If this is an old file,
        Press <Enter> key, then R for replace.
        If you have a new file,
        Type in new name.   Press <Enter> key.
                                - 28 -





  √√√ WINDOWS
        Windows allows you to look at two different parts of a
        worksheet at the same time. This is good way to make comparison
        from say one month to another. Or for any comparison of set of data
        to another.

        The Formula goes like this:
        Move the cursor down about 10 rows.
        Your screen will have a second heading at line 10.
        You can move the cursor in any direction.
        When you move cursor down it will continue to change rows while
        the lower half of the window remains stationary.

        To cross over to the other window Press the F6 function key
        Now if you move the cursor upward it will change cells while the
        upper window remains stationary.

  √√√   TO RETURN TO ONE WORKSHEET
        Use W W C  (C for clear).
        In the horizontal mode both windows move at the same time.

  √√√   TO UNSYNC USE  W W Unsync.

                        *** END OF CHAPTER ***

                   Press <Esc> key to return to Menu.

                 Select Pie Graph And Press <Enter> key.































                                - 29 -